Setting general connection properties

This section describes how to configure general connection properties.

To add an ODBC with CDC source endpoint to Qlik Replicate:

1. In the Qlik Replicate console, click the Manage Endpoint Connections toolbar button to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button. For more information on adding an endpoint to Qlik Replicate, see Defining and managing endpoints.
2. In the Name field, type a name for your ODBC endpoint. This can be any name that will help to identify the endpoint being used.
3. In the Description field, type a description that helps to identify the ODBC endpoint. This is optional.
4. Select Source as the endpoint role.

5. Select ODBC with CDC as the endpoint Type.

   Information note

   When this endpoint is used as a duplicated source in a Log Stream Staging setup, select the Read changes from log stream check box and then select the relevant Log Stream Staging task from the drop-down list.

   For information on setting up and managing Log Stream Staging tasks, see Using the Log Stream.

6. Select one of the following:

   • DSN: Select this to connect to an ODBC-supported endpoint using a DSN. When you select DSN you must select the DSN you are using from the list.

     If the DSN you want to use is not included in the list, make sure that the endpoint client is installed on the computer with Qlik Replicate and that the DSN is defined. Note that the ODBC provider client must be 64-bit. For more information, see Prerequisites .

     Information note

     If you are using a Replicate Connect CDC Agent as the source in a Replicate task, you cannot select the DSN for the Qlik ODBC driver as the target. In this case, to use Qlik ODBC as a source, you must enter the connection string manually by selecting Connection String and following the directions for that option in this procedure.

   • Connection String: Select this to connect to an ODBC-supported endpoint using a connection string then type a valid connection string in the field below. For information on how to create a connection string, see the documentation for the ODBC endpoint provider you are using.

     Note that if you specify a password in your connection string, it will be revealed as plain text in the task log files. It is therefore recommended to specify the password in the GUI Password field.

     Information note

     To determine if you are connected to the endpoint you want to use or if the connection information you entered is correct, click Test Connection.

     If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

     To view the log entry if the connection fails, click View Log (this button is not available unless the test connection fails). The server log is displayed with the information for the connection failure.

7. Type the authentication information (User Name, Password) for the authorized user for the ODBC endpoint being used. For example, the IBM DB2 system administrator if you are using a IBM DB2 provider. If you do not know this information, see your ODBC Endpoint System Administrator.

   Information note

   Consider the following:

   • If you select Connection String, be sure to include User name/password information in the connection string that you type in the box.

   • This information is case sensitive.
   Information note

   Make sure that the ODBC endpoint user has the correct access privileges for the ODBC provider being used.